package com.lilosoft.business.precity.models;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class UpProAcceptExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UpProAcceptExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRowguidIsNull() {
            addCriterion("ROWGUID is null");
            return (Criteria) this;
        }

        public Criteria andRowguidIsNotNull() {
            addCriterion("ROWGUID is not null");
            return (Criteria) this;
        }

        public Criteria andRowguidEqualTo(String value) {
            addCriterion("ROWGUID =", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotEqualTo(String value) {
            addCriterion("ROWGUID <>", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidGreaterThan(String value) {
            addCriterion("ROWGUID >", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidGreaterThanOrEqualTo(String value) {
            addCriterion("ROWGUID >=", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidLessThan(String value) {
            addCriterion("ROWGUID <", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidLessThanOrEqualTo(String value) {
            addCriterion("ROWGUID <=", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidLike(String value) {
            addCriterion("ROWGUID like", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotLike(String value) {
            addCriterion("ROWGUID not like", value, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidIn(List<String> values) {
            addCriterion("ROWGUID in", values, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotIn(List<String> values) {
            addCriterion("ROWGUID not in", values, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidBetween(String value1, String value2) {
            addCriterion("ROWGUID between", value1, value2, "rowguid");
            return (Criteria) this;
        }

        public Criteria andRowguidNotBetween(String value1, String value2) {
            addCriterion("ROWGUID not between", value1, value2, "rowguid");
            return (Criteria) this;
        }

        public Criteria andProjectnoIsNull() {
            addCriterion("PROJECTNO is null");
            return (Criteria) this;
        }

        public Criteria andProjectnoIsNotNull() {
            addCriterion("PROJECTNO is not null");
            return (Criteria) this;
        }

        public Criteria andProjectnoEqualTo(String value) {
            addCriterion("PROJECTNO =", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotEqualTo(String value) {
            addCriterion("PROJECTNO <>", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoGreaterThan(String value) {
            addCriterion("PROJECTNO >", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECTNO >=", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoLessThan(String value) {
            addCriterion("PROJECTNO <", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoLessThanOrEqualTo(String value) {
            addCriterion("PROJECTNO <=", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoLike(String value) {
            addCriterion("PROJECTNO like", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotLike(String value) {
            addCriterion("PROJECTNO not like", value, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoIn(List<String> values) {
            addCriterion("PROJECTNO in", values, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotIn(List<String> values) {
            addCriterion("PROJECTNO not in", values, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoBetween(String value1, String value2) {
            addCriterion("PROJECTNO between", value1, value2, "projectno");
            return (Criteria) this;
        }

        public Criteria andProjectnoNotBetween(String value1, String value2) {
            addCriterion("PROJECTNO not between", value1, value2, "projectno");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeIsNull() {
            addCriterion("CATALOGCODE is null");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeIsNotNull() {
            addCriterion("CATALOGCODE is not null");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeEqualTo(String value) {
            addCriterion("CATALOGCODE =", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeNotEqualTo(String value) {
            addCriterion("CATALOGCODE <>", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeGreaterThan(String value) {
            addCriterion("CATALOGCODE >", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeGreaterThanOrEqualTo(String value) {
            addCriterion("CATALOGCODE >=", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeLessThan(String value) {
            addCriterion("CATALOGCODE <", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeLessThanOrEqualTo(String value) {
            addCriterion("CATALOGCODE <=", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeLike(String value) {
            addCriterion("CATALOGCODE like", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeNotLike(String value) {
            addCriterion("CATALOGCODE not like", value, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeIn(List<String> values) {
            addCriterion("CATALOGCODE in", values, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeNotIn(List<String> values) {
            addCriterion("CATALOGCODE not in", values, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeBetween(String value1, String value2) {
            addCriterion("CATALOGCODE between", value1, value2, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andCatalogcodeNotBetween(String value1, String value2) {
            addCriterion("CATALOGCODE not between", value1, value2, "catalogcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeIsNull() {
            addCriterion("TASKCODE is null");
            return (Criteria) this;
        }

        public Criteria andTaskcodeIsNotNull() {
            addCriterion("TASKCODE is not null");
            return (Criteria) this;
        }

        public Criteria andTaskcodeEqualTo(String value) {
            addCriterion("TASKCODE =", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeNotEqualTo(String value) {
            addCriterion("TASKCODE <>", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeGreaterThan(String value) {
            addCriterion("TASKCODE >", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeGreaterThanOrEqualTo(String value) {
            addCriterion("TASKCODE >=", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeLessThan(String value) {
            addCriterion("TASKCODE <", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeLessThanOrEqualTo(String value) {
            addCriterion("TASKCODE <=", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeLike(String value) {
            addCriterion("TASKCODE like", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeNotLike(String value) {
            addCriterion("TASKCODE not like", value, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeIn(List<String> values) {
            addCriterion("TASKCODE in", values, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeNotIn(List<String> values) {
            addCriterion("TASKCODE not in", values, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeBetween(String value1, String value2) {
            addCriterion("TASKCODE between", value1, value2, "taskcode");
            return (Criteria) this;
        }

        public Criteria andTaskcodeNotBetween(String value1, String value2) {
            addCriterion("TASKCODE not between", value1, value2, "taskcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeIsNull() {
            addCriterion("LOCALCATALOGCODE is null");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeIsNotNull() {
            addCriterion("LOCALCATALOGCODE is not null");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeEqualTo(String value) {
            addCriterion("LOCALCATALOGCODE =", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeNotEqualTo(String value) {
            addCriterion("LOCALCATALOGCODE <>", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeGreaterThan(String value) {
            addCriterion("LOCALCATALOGCODE >", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeGreaterThanOrEqualTo(String value) {
            addCriterion("LOCALCATALOGCODE >=", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeLessThan(String value) {
            addCriterion("LOCALCATALOGCODE <", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeLessThanOrEqualTo(String value) {
            addCriterion("LOCALCATALOGCODE <=", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeLike(String value) {
            addCriterion("LOCALCATALOGCODE like", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeNotLike(String value) {
            addCriterion("LOCALCATALOGCODE not like", value, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeIn(List<String> values) {
            addCriterion("LOCALCATALOGCODE in", values, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeNotIn(List<String> values) {
            addCriterion("LOCALCATALOGCODE not in", values, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeBetween(String value1, String value2) {
            addCriterion("LOCALCATALOGCODE between", value1, value2, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocalcatalogcodeNotBetween(String value1, String value2) {
            addCriterion("LOCALCATALOGCODE not between", value1, value2, "localcatalogcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeIsNull() {
            addCriterion("LOCALTASKCODE is null");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeIsNotNull() {
            addCriterion("LOCALTASKCODE is not null");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeEqualTo(String value) {
            addCriterion("LOCALTASKCODE =", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeNotEqualTo(String value) {
            addCriterion("LOCALTASKCODE <>", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeGreaterThan(String value) {
            addCriterion("LOCALTASKCODE >", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeGreaterThanOrEqualTo(String value) {
            addCriterion("LOCALTASKCODE >=", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeLessThan(String value) {
            addCriterion("LOCALTASKCODE <", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeLessThanOrEqualTo(String value) {
            addCriterion("LOCALTASKCODE <=", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeLike(String value) {
            addCriterion("LOCALTASKCODE like", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeNotLike(String value) {
            addCriterion("LOCALTASKCODE not like", value, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeIn(List<String> values) {
            addCriterion("LOCALTASKCODE in", values, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeNotIn(List<String> values) {
            addCriterion("LOCALTASKCODE not in", values, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeBetween(String value1, String value2) {
            addCriterion("LOCALTASKCODE between", value1, value2, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andLocaltaskcodeNotBetween(String value1, String value2) {
            addCriterion("LOCALTASKCODE not between", value1, value2, "localtaskcode");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemIsNull() {
            addCriterion("TASKHANDLEITEM is null");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemIsNotNull() {
            addCriterion("TASKHANDLEITEM is not null");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemEqualTo(String value) {
            addCriterion("TASKHANDLEITEM =", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemNotEqualTo(String value) {
            addCriterion("TASKHANDLEITEM <>", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemGreaterThan(String value) {
            addCriterion("TASKHANDLEITEM >", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemGreaterThanOrEqualTo(String value) {
            addCriterion("TASKHANDLEITEM >=", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemLessThan(String value) {
            addCriterion("TASKHANDLEITEM <", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemLessThanOrEqualTo(String value) {
            addCriterion("TASKHANDLEITEM <=", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemLike(String value) {
            addCriterion("TASKHANDLEITEM like", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemNotLike(String value) {
            addCriterion("TASKHANDLEITEM not like", value, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemIn(List<String> values) {
            addCriterion("TASKHANDLEITEM in", values, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemNotIn(List<String> values) {
            addCriterion("TASKHANDLEITEM not in", values, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemBetween(String value1, String value2) {
            addCriterion("TASKHANDLEITEM between", value1, value2, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTaskhandleitemNotBetween(String value1, String value2) {
            addCriterion("TASKHANDLEITEM not between", value1, value2, "taskhandleitem");
            return (Criteria) this;
        }

        public Criteria andTasktypeIsNull() {
            addCriterion("TASKTYPE is null");
            return (Criteria) this;
        }

        public Criteria andTasktypeIsNotNull() {
            addCriterion("TASKTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTasktypeEqualTo(String value) {
            addCriterion("TASKTYPE =", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeNotEqualTo(String value) {
            addCriterion("TASKTYPE <>", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeGreaterThan(String value) {
            addCriterion("TASKTYPE >", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeGreaterThanOrEqualTo(String value) {
            addCriterion("TASKTYPE >=", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeLessThan(String value) {
            addCriterion("TASKTYPE <", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeLessThanOrEqualTo(String value) {
            addCriterion("TASKTYPE <=", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeLike(String value) {
            addCriterion("TASKTYPE like", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeNotLike(String value) {
            addCriterion("TASKTYPE not like", value, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeIn(List<String> values) {
            addCriterion("TASKTYPE in", values, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeNotIn(List<String> values) {
            addCriterion("TASKTYPE not in", values, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeBetween(String value1, String value2) {
            addCriterion("TASKTYPE between", value1, value2, "tasktype");
            return (Criteria) this;
        }

        public Criteria andTasktypeNotBetween(String value1, String value2) {
            addCriterion("TASKTYPE not between", value1, value2, "tasktype");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNull() {
            addCriterion("ITEM_ID is null");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNotNull() {
            addCriterion("ITEM_ID is not null");
            return (Criteria) this;
        }

        public Criteria andItemIdEqualTo(String value) {
            addCriterion("ITEM_ID =", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotEqualTo(String value) {
            addCriterion("ITEM_ID <>", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThan(String value) {
            addCriterion("ITEM_ID >", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThanOrEqualTo(String value) {
            addCriterion("ITEM_ID >=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThan(String value) {
            addCriterion("ITEM_ID <", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThanOrEqualTo(String value) {
            addCriterion("ITEM_ID <=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLike(String value) {
            addCriterion("ITEM_ID like", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotLike(String value) {
            addCriterion("ITEM_ID not like", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdIn(List<String> values) {
            addCriterion("ITEM_ID in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotIn(List<String> values) {
            addCriterion("ITEM_ID not in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdBetween(String value1, String value2) {
            addCriterion("ITEM_ID between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotBetween(String value1, String value2) {
            addCriterion("ITEM_ID not between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsIsNull() {
            addCriterion("ISFIXEDASSETS is null");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsIsNotNull() {
            addCriterion("ISFIXEDASSETS is not null");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsEqualTo(String value) {
            addCriterion("ISFIXEDASSETS =", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsNotEqualTo(String value) {
            addCriterion("ISFIXEDASSETS <>", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsGreaterThan(String value) {
            addCriterion("ISFIXEDASSETS >", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsGreaterThanOrEqualTo(String value) {
            addCriterion("ISFIXEDASSETS >=", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsLessThan(String value) {
            addCriterion("ISFIXEDASSETS <", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsLessThanOrEqualTo(String value) {
            addCriterion("ISFIXEDASSETS <=", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsLike(String value) {
            addCriterion("ISFIXEDASSETS like", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsNotLike(String value) {
            addCriterion("ISFIXEDASSETS not like", value, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsIn(List<String> values) {
            addCriterion("ISFIXEDASSETS in", values, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsNotIn(List<String> values) {
            addCriterion("ISFIXEDASSETS not in", values, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsBetween(String value1, String value2) {
            addCriterion("ISFIXEDASSETS between", value1, value2, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andIsfixedassetsNotBetween(String value1, String value2) {
            addCriterion("ISFIXEDASSETS not between", value1, value2, "isfixedassets");
            return (Criteria) this;
        }

        public Criteria andApplytypeIsNull() {
            addCriterion("APPLYTYPE is null");
            return (Criteria) this;
        }

        public Criteria andApplytypeIsNotNull() {
            addCriterion("APPLYTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andApplytypeEqualTo(String value) {
            addCriterion("APPLYTYPE =", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeNotEqualTo(String value) {
            addCriterion("APPLYTYPE <>", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeGreaterThan(String value) {
            addCriterion("APPLYTYPE >", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeGreaterThanOrEqualTo(String value) {
            addCriterion("APPLYTYPE >=", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeLessThan(String value) {
            addCriterion("APPLYTYPE <", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeLessThanOrEqualTo(String value) {
            addCriterion("APPLYTYPE <=", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeLike(String value) {
            addCriterion("APPLYTYPE like", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeNotLike(String value) {
            addCriterion("APPLYTYPE not like", value, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeIn(List<String> values) {
            addCriterion("APPLYTYPE in", values, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeNotIn(List<String> values) {
            addCriterion("APPLYTYPE not in", values, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeBetween(String value1, String value2) {
            addCriterion("APPLYTYPE between", value1, value2, "applytype");
            return (Criteria) this;
        }

        public Criteria andApplytypeNotBetween(String value1, String value2) {
            addCriterion("APPLYTYPE not between", value1, value2, "applytype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeIsNull() {
            addCriterion("PROJECTTYPE is null");
            return (Criteria) this;
        }

        public Criteria andProjecttypeIsNotNull() {
            addCriterion("PROJECTTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andProjecttypeEqualTo(String value) {
            addCriterion("PROJECTTYPE =", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeNotEqualTo(String value) {
            addCriterion("PROJECTTYPE <>", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeGreaterThan(String value) {
            addCriterion("PROJECTTYPE >", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECTTYPE >=", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeLessThan(String value) {
            addCriterion("PROJECTTYPE <", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeLessThanOrEqualTo(String value) {
            addCriterion("PROJECTTYPE <=", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeLike(String value) {
            addCriterion("PROJECTTYPE like", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeNotLike(String value) {
            addCriterion("PROJECTTYPE not like", value, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeIn(List<String> values) {
            addCriterion("PROJECTTYPE in", values, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeNotIn(List<String> values) {
            addCriterion("PROJECTTYPE not in", values, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeBetween(String value1, String value2) {
            addCriterion("PROJECTTYPE between", value1, value2, "projecttype");
            return (Criteria) this;
        }

        public Criteria andProjecttypeNotBetween(String value1, String value2) {
            addCriterion("PROJECTTYPE not between", value1, value2, "projecttype");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceIsNull() {
            addCriterion("TRANSACTION_SOURCE is null");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceIsNotNull() {
            addCriterion("TRANSACTION_SOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceEqualTo(Integer value) {
            addCriterion("TRANSACTION_SOURCE =", value, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceNotEqualTo(Integer value) {
            addCriterion("TRANSACTION_SOURCE <>", value, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceGreaterThan(Integer value) {
            addCriterion("TRANSACTION_SOURCE >", value, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("TRANSACTION_SOURCE >=", value, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceLessThan(Integer value) {
            addCriterion("TRANSACTION_SOURCE <", value, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceLessThanOrEqualTo(Integer value) {
            addCriterion("TRANSACTION_SOURCE <=", value, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceIn(List<Integer> values) {
            addCriterion("TRANSACTION_SOURCE in", values, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceNotIn(List<Integer> values) {
            addCriterion("TRANSACTION_SOURCE not in", values, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceBetween(Integer value1, Integer value2) {
            addCriterion("TRANSACTION_SOURCE between", value1, value2, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionSourceNotBetween(Integer value1, Integer value2) {
            addCriterion("TRANSACTION_SOURCE not between", value1, value2, "transactionSource");
            return (Criteria) this;
        }

        public Criteria andTransactionStateIsNull() {
            addCriterion("TRANSACTION_STATE is null");
            return (Criteria) this;
        }

        public Criteria andTransactionStateIsNotNull() {
            addCriterion("TRANSACTION_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionStateEqualTo(Integer value) {
            addCriterion("TRANSACTION_STATE =", value, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateNotEqualTo(Integer value) {
            addCriterion("TRANSACTION_STATE <>", value, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateGreaterThan(Integer value) {
            addCriterion("TRANSACTION_STATE >", value, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("TRANSACTION_STATE >=", value, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateLessThan(Integer value) {
            addCriterion("TRANSACTION_STATE <", value, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateLessThanOrEqualTo(Integer value) {
            addCriterion("TRANSACTION_STATE <=", value, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateIn(List<Integer> values) {
            addCriterion("TRANSACTION_STATE in", values, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateNotIn(List<Integer> values) {
            addCriterion("TRANSACTION_STATE not in", values, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateBetween(Integer value1, Integer value2) {
            addCriterion("TRANSACTION_STATE between", value1, value2, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTransactionStateNotBetween(Integer value1, Integer value2) {
            addCriterion("TRANSACTION_STATE not between", value1, value2, "transactionState");
            return (Criteria) this;
        }

        public Criteria andTaskversionIsNull() {
            addCriterion("TASKVERSION is null");
            return (Criteria) this;
        }

        public Criteria andTaskversionIsNotNull() {
            addCriterion("TASKVERSION is not null");
            return (Criteria) this;
        }

        public Criteria andTaskversionEqualTo(Integer value) {
            addCriterion("TASKVERSION =", value, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionNotEqualTo(Integer value) {
            addCriterion("TASKVERSION <>", value, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionGreaterThan(Integer value) {
            addCriterion("TASKVERSION >", value, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionGreaterThanOrEqualTo(Integer value) {
            addCriterion("TASKVERSION >=", value, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionLessThan(Integer value) {
            addCriterion("TASKVERSION <", value, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionLessThanOrEqualTo(Integer value) {
            addCriterion("TASKVERSION <=", value, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionIn(List<Integer> values) {
            addCriterion("TASKVERSION in", values, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionNotIn(List<Integer> values) {
            addCriterion("TASKVERSION not in", values, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionBetween(Integer value1, Integer value2) {
            addCriterion("TASKVERSION between", value1, value2, "taskversion");
            return (Criteria) this;
        }

        public Criteria andTaskversionNotBetween(Integer value1, Integer value2) {
            addCriterion("TASKVERSION not between", value1, value2, "taskversion");
            return (Criteria) this;
        }

        public Criteria andApplyertypeIsNull() {
            addCriterion("APPLYERTYPE is null");
            return (Criteria) this;
        }

        public Criteria andApplyertypeIsNotNull() {
            addCriterion("APPLYERTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andApplyertypeEqualTo(String value) {
            addCriterion("APPLYERTYPE =", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeNotEqualTo(String value) {
            addCriterion("APPLYERTYPE <>", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeGreaterThan(String value) {
            addCriterion("APPLYERTYPE >", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeGreaterThanOrEqualTo(String value) {
            addCriterion("APPLYERTYPE >=", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeLessThan(String value) {
            addCriterion("APPLYERTYPE <", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeLessThanOrEqualTo(String value) {
            addCriterion("APPLYERTYPE <=", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeLike(String value) {
            addCriterion("APPLYERTYPE like", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeNotLike(String value) {
            addCriterion("APPLYERTYPE not like", value, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeIn(List<String> values) {
            addCriterion("APPLYERTYPE in", values, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeNotIn(List<String> values) {
            addCriterion("APPLYERTYPE not in", values, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeBetween(String value1, String value2) {
            addCriterion("APPLYERTYPE between", value1, value2, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyertypeNotBetween(String value1, String value2) {
            addCriterion("APPLYERTYPE not between", value1, value2, "applyertype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeIsNull() {
            addCriterion("APPLYERPAGETYPE is null");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeIsNotNull() {
            addCriterion("APPLYERPAGETYPE is not null");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeEqualTo(String value) {
            addCriterion("APPLYERPAGETYPE =", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeNotEqualTo(String value) {
            addCriterion("APPLYERPAGETYPE <>", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeGreaterThan(String value) {
            addCriterion("APPLYERPAGETYPE >", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeGreaterThanOrEqualTo(String value) {
            addCriterion("APPLYERPAGETYPE >=", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeLessThan(String value) {
            addCriterion("APPLYERPAGETYPE <", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeLessThanOrEqualTo(String value) {
            addCriterion("APPLYERPAGETYPE <=", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeLike(String value) {
            addCriterion("APPLYERPAGETYPE like", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeNotLike(String value) {
            addCriterion("APPLYERPAGETYPE not like", value, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeIn(List<String> values) {
            addCriterion("APPLYERPAGETYPE in", values, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeNotIn(List<String> values) {
            addCriterion("APPLYERPAGETYPE not in", values, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeBetween(String value1, String value2) {
            addCriterion("APPLYERPAGETYPE between", value1, value2, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyerpagetypeNotBetween(String value1, String value2) {
            addCriterion("APPLYERPAGETYPE not between", value1, value2, "applyerpagetype");
            return (Criteria) this;
        }

        public Criteria andApplyernameIsNull() {
            addCriterion("APPLYERNAME is null");
            return (Criteria) this;
        }

        public Criteria andApplyernameIsNotNull() {
            addCriterion("APPLYERNAME is not null");
            return (Criteria) this;
        }

        public Criteria andApplyernameEqualTo(String value) {
            addCriterion("APPLYERNAME =", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameNotEqualTo(String value) {
            addCriterion("APPLYERNAME <>", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameGreaterThan(String value) {
            addCriterion("APPLYERNAME >", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameGreaterThanOrEqualTo(String value) {
            addCriterion("APPLYERNAME >=", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameLessThan(String value) {
            addCriterion("APPLYERNAME <", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameLessThanOrEqualTo(String value) {
            addCriterion("APPLYERNAME <=", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameLike(String value) {
            addCriterion("APPLYERNAME like", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameNotLike(String value) {
            addCriterion("APPLYERNAME not like", value, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameIn(List<String> values) {
            addCriterion("APPLYERNAME in", values, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameNotIn(List<String> values) {
            addCriterion("APPLYERNAME not in", values, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameBetween(String value1, String value2) {
            addCriterion("APPLYERNAME between", value1, value2, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplyernameNotBetween(String value1, String value2) {
            addCriterion("APPLYERNAME not between", value1, value2, "applyername");
            return (Criteria) this;
        }

        public Criteria andApplydateIsNull() {
            addCriterion("APPLYDATE is null");
            return (Criteria) this;
        }

        public Criteria andApplydateIsNotNull() {
            addCriterion("APPLYDATE is not null");
            return (Criteria) this;
        }

        public Criteria andApplydateEqualTo(Date value) {
            addCriterion("APPLYDATE =", value, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateNotEqualTo(Date value) {
            addCriterion("APPLYDATE <>", value, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateGreaterThan(Date value) {
            addCriterion("APPLYDATE >", value, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateGreaterThanOrEqualTo(Date value) {
            addCriterion("APPLYDATE >=", value, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateLessThan(Date value) {
            addCriterion("APPLYDATE <", value, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateLessThanOrEqualTo(Date value) {
            addCriterion("APPLYDATE <=", value, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateIn(List<Date> values) {
            addCriterion("APPLYDATE in", values, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateNotIn(List<Date> values) {
            addCriterion("APPLYDATE not in", values, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateBetween(Date value1, Date value2) {
            addCriterion("APPLYDATE between", value1, value2, "applydate");
            return (Criteria) this;
        }

        public Criteria andApplydateNotBetween(Date value1, Date value2) {
            addCriterion("APPLYDATE not between", value1, value2, "applydate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateIsNull() {
            addCriterion("RECEIPT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andReceiptDateIsNotNull() {
            addCriterion("RECEIPT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andReceiptDateEqualTo(Date value) {
            addCriterion("RECEIPT_DATE =", value, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateNotEqualTo(Date value) {
            addCriterion("RECEIPT_DATE <>", value, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateGreaterThan(Date value) {
            addCriterion("RECEIPT_DATE >", value, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateGreaterThanOrEqualTo(Date value) {
            addCriterion("RECEIPT_DATE >=", value, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateLessThan(Date value) {
            addCriterion("RECEIPT_DATE <", value, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateLessThanOrEqualTo(Date value) {
            addCriterion("RECEIPT_DATE <=", value, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateIn(List<Date> values) {
            addCriterion("RECEIPT_DATE in", values, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateNotIn(List<Date> values) {
            addCriterion("RECEIPT_DATE not in", values, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateBetween(Date value1, Date value2) {
            addCriterion("RECEIPT_DATE between", value1, value2, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andReceiptDateNotBetween(Date value1, Date value2) {
            addCriterion("RECEIPT_DATE not between", value1, value2, "receiptDate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateIsNull() {
            addCriterion("ACCEPTDATE is null");
            return (Criteria) this;
        }

        public Criteria andAcceptdateIsNotNull() {
            addCriterion("ACCEPTDATE is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptdateEqualTo(Date value) {
            addCriterion("ACCEPTDATE =", value, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateNotEqualTo(Date value) {
            addCriterion("ACCEPTDATE <>", value, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateGreaterThan(Date value) {
            addCriterion("ACCEPTDATE >", value, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateGreaterThanOrEqualTo(Date value) {
            addCriterion("ACCEPTDATE >=", value, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateLessThan(Date value) {
            addCriterion("ACCEPTDATE <", value, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateLessThanOrEqualTo(Date value) {
            addCriterion("ACCEPTDATE <=", value, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateIn(List<Date> values) {
            addCriterion("ACCEPTDATE in", values, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateNotIn(List<Date> values) {
            addCriterion("ACCEPTDATE not in", values, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateBetween(Date value1, Date value2) {
            addCriterion("ACCEPTDATE between", value1, value2, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andAcceptdateNotBetween(Date value1, Date value2) {
            addCriterion("ACCEPTDATE not between", value1, value2, "acceptdate");
            return (Criteria) this;
        }

        public Criteria andPromisedateIsNull() {
            addCriterion("PROMISEDATE is null");
            return (Criteria) this;
        }

        public Criteria andPromisedateIsNotNull() {
            addCriterion("PROMISEDATE is not null");
            return (Criteria) this;
        }

        public Criteria andPromisedateEqualTo(Date value) {
            addCriterion("PROMISEDATE =", value, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateNotEqualTo(Date value) {
            addCriterion("PROMISEDATE <>", value, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateGreaterThan(Date value) {
            addCriterion("PROMISEDATE >", value, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateGreaterThanOrEqualTo(Date value) {
            addCriterion("PROMISEDATE >=", value, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateLessThan(Date value) {
            addCriterion("PROMISEDATE <", value, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateLessThanOrEqualTo(Date value) {
            addCriterion("PROMISEDATE <=", value, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateIn(List<Date> values) {
            addCriterion("PROMISEDATE in", values, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateNotIn(List<Date> values) {
            addCriterion("PROMISEDATE not in", values, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateBetween(Date value1, Date value2) {
            addCriterion("PROMISEDATE between", value1, value2, "promisedate");
            return (Criteria) this;
        }

        public Criteria andPromisedateNotBetween(Date value1, Date value2) {
            addCriterion("PROMISEDATE not between", value1, value2, "promisedate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateIsNull() {
            addCriterion("CONCLUDED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andConcludedDateIsNotNull() {
            addCriterion("CONCLUDED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andConcludedDateEqualTo(Date value) {
            addCriterion("CONCLUDED_DATE =", value, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateNotEqualTo(Date value) {
            addCriterion("CONCLUDED_DATE <>", value, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateGreaterThan(Date value) {
            addCriterion("CONCLUDED_DATE >", value, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CONCLUDED_DATE >=", value, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateLessThan(Date value) {
            addCriterion("CONCLUDED_DATE <", value, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateLessThanOrEqualTo(Date value) {
            addCriterion("CONCLUDED_DATE <=", value, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateIn(List<Date> values) {
            addCriterion("CONCLUDED_DATE in", values, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateNotIn(List<Date> values) {
            addCriterion("CONCLUDED_DATE not in", values, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateBetween(Date value1, Date value2) {
            addCriterion("CONCLUDED_DATE between", value1, value2, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andConcludedDateNotBetween(Date value1, Date value2) {
            addCriterion("CONCLUDED_DATE not between", value1, value2, "concludedDate");
            return (Criteria) this;
        }

        public Criteria andOrgIdIsNull() {
            addCriterion("ORG_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrgIdIsNotNull() {
            addCriterion("ORG_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrgIdEqualTo(String value) {
            addCriterion("ORG_ID =", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotEqualTo(String value) {
            addCriterion("ORG_ID <>", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThan(String value) {
            addCriterion("ORG_ID >", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_ID >=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThan(String value) {
            addCriterion("ORG_ID <", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThanOrEqualTo(String value) {
            addCriterion("ORG_ID <=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLike(String value) {
            addCriterion("ORG_ID like", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotLike(String value) {
            addCriterion("ORG_ID not like", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdIn(List<String> values) {
            addCriterion("ORG_ID in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotIn(List<String> values) {
            addCriterion("ORG_ID not in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdBetween(String value1, String value2) {
            addCriterion("ORG_ID between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotBetween(String value1, String value2) {
            addCriterion("ORG_ID not between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIsNull() {
            addCriterion("ORGCODE is null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIsNotNull() {
            addCriterion("ORGCODE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeEqualTo(String value) {
            addCriterion("ORGCODE =", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotEqualTo(String value) {
            addCriterion("ORGCODE <>", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeGreaterThan(String value) {
            addCriterion("ORGCODE >", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORGCODE >=", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLessThan(String value) {
            addCriterion("ORGCODE <", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLessThanOrEqualTo(String value) {
            addCriterion("ORGCODE <=", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLike(String value) {
            addCriterion("ORGCODE like", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotLike(String value) {
            addCriterion("ORGCODE not like", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIn(List<String> values) {
            addCriterion("ORGCODE in", values, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotIn(List<String> values) {
            addCriterion("ORGCODE not in", values, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeBetween(String value1, String value2) {
            addCriterion("ORGCODE between", value1, value2, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotBetween(String value1, String value2) {
            addCriterion("ORGCODE not between", value1, value2, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgnameIsNull() {
            addCriterion("ORGNAME is null");
            return (Criteria) this;
        }

        public Criteria andOrgnameIsNotNull() {
            addCriterion("ORGNAME is not null");
            return (Criteria) this;
        }

        public Criteria andOrgnameEqualTo(String value) {
            addCriterion("ORGNAME =", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameNotEqualTo(String value) {
            addCriterion("ORGNAME <>", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameGreaterThan(String value) {
            addCriterion("ORGNAME >", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameGreaterThanOrEqualTo(String value) {
            addCriterion("ORGNAME >=", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameLessThan(String value) {
            addCriterion("ORGNAME <", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameLessThanOrEqualTo(String value) {
            addCriterion("ORGNAME <=", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameLike(String value) {
            addCriterion("ORGNAME like", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameNotLike(String value) {
            addCriterion("ORGNAME not like", value, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameIn(List<String> values) {
            addCriterion("ORGNAME in", values, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameNotIn(List<String> values) {
            addCriterion("ORGNAME not in", values, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameBetween(String value1, String value2) {
            addCriterion("ORGNAME between", value1, value2, "orgname");
            return (Criteria) this;
        }

        public Criteria andOrgnameNotBetween(String value1, String value2) {
            addCriterion("ORGNAME not between", value1, value2, "orgname");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdIsNull() {
            addCriterion("HANDLEUSER_ID is null");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdIsNotNull() {
            addCriterion("HANDLEUSER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdEqualTo(String value) {
            addCriterion("HANDLEUSER_ID =", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdNotEqualTo(String value) {
            addCriterion("HANDLEUSER_ID <>", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdGreaterThan(String value) {
            addCriterion("HANDLEUSER_ID >", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdGreaterThanOrEqualTo(String value) {
            addCriterion("HANDLEUSER_ID >=", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdLessThan(String value) {
            addCriterion("HANDLEUSER_ID <", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdLessThanOrEqualTo(String value) {
            addCriterion("HANDLEUSER_ID <=", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdLike(String value) {
            addCriterion("HANDLEUSER_ID like", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdNotLike(String value) {
            addCriterion("HANDLEUSER_ID not like", value, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdIn(List<String> values) {
            addCriterion("HANDLEUSER_ID in", values, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdNotIn(List<String> values) {
            addCriterion("HANDLEUSER_ID not in", values, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdBetween(String value1, String value2) {
            addCriterion("HANDLEUSER_ID between", value1, value2, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andHandleuserIdNotBetween(String value1, String value2) {
            addCriterion("HANDLEUSER_ID not between", value1, value2, "handleuserId");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoIsNull() {
            addCriterion("ACCEPTDOCNO is null");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoIsNotNull() {
            addCriterion("ACCEPTDOCNO is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoEqualTo(String value) {
            addCriterion("ACCEPTDOCNO =", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoNotEqualTo(String value) {
            addCriterion("ACCEPTDOCNO <>", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoGreaterThan(String value) {
            addCriterion("ACCEPTDOCNO >", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoGreaterThanOrEqualTo(String value) {
            addCriterion("ACCEPTDOCNO >=", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoLessThan(String value) {
            addCriterion("ACCEPTDOCNO <", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoLessThanOrEqualTo(String value) {
            addCriterion("ACCEPTDOCNO <=", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoLike(String value) {
            addCriterion("ACCEPTDOCNO like", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoNotLike(String value) {
            addCriterion("ACCEPTDOCNO not like", value, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoIn(List<String> values) {
            addCriterion("ACCEPTDOCNO in", values, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoNotIn(List<String> values) {
            addCriterion("ACCEPTDOCNO not in", values, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoBetween(String value1, String value2) {
            addCriterion("ACCEPTDOCNO between", value1, value2, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andAcceptdocnoNotBetween(String value1, String value2) {
            addCriterion("ACCEPTDOCNO not between", value1, value2, "acceptdocno");
            return (Criteria) this;
        }

        public Criteria andIsFeeIsNull() {
            addCriterion("IS_FEE is null");
            return (Criteria) this;
        }

        public Criteria andIsFeeIsNotNull() {
            addCriterion("IS_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andIsFeeEqualTo(String value) {
            addCriterion("IS_FEE =", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeNotEqualTo(String value) {
            addCriterion("IS_FEE <>", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeGreaterThan(String value) {
            addCriterion("IS_FEE >", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeGreaterThanOrEqualTo(String value) {
            addCriterion("IS_FEE >=", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeLessThan(String value) {
            addCriterion("IS_FEE <", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeLessThanOrEqualTo(String value) {
            addCriterion("IS_FEE <=", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeLike(String value) {
            addCriterion("IS_FEE like", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeNotLike(String value) {
            addCriterion("IS_FEE not like", value, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeIn(List<String> values) {
            addCriterion("IS_FEE in", values, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeNotIn(List<String> values) {
            addCriterion("IS_FEE not in", values, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeBetween(String value1, String value2) {
            addCriterion("IS_FEE between", value1, value2, "isFee");
            return (Criteria) this;
        }

        public Criteria andIsFeeNotBetween(String value1, String value2) {
            addCriterion("IS_FEE not between", value1, value2, "isFee");
            return (Criteria) this;
        }

        public Criteria andFeeIsNull() {
            addCriterion("FEE is null");
            return (Criteria) this;
        }

        public Criteria andFeeIsNotNull() {
            addCriterion("FEE is not null");
            return (Criteria) this;
        }

        public Criteria andFeeEqualTo(String value) {
            addCriterion("FEE =", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotEqualTo(String value) {
            addCriterion("FEE <>", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThan(String value) {
            addCriterion("FEE >", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThanOrEqualTo(String value) {
            addCriterion("FEE >=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThan(String value) {
            addCriterion("FEE <", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThanOrEqualTo(String value) {
            addCriterion("FEE <=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLike(String value) {
            addCriterion("FEE like", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotLike(String value) {
            addCriterion("FEE not like", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeIn(List<String> values) {
            addCriterion("FEE in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotIn(List<String> values) {
            addCriterion("FEE not in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeBetween(String value1, String value2) {
            addCriterion("FEE between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotBetween(String value1, String value2) {
            addCriterion("FEE not between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andCheckStateIsNull() {
            addCriterion("CHECK_STATE is null");
            return (Criteria) this;
        }

        public Criteria andCheckStateIsNotNull() {
            addCriterion("CHECK_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andCheckStateEqualTo(Integer value) {
            addCriterion("CHECK_STATE =", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateNotEqualTo(Integer value) {
            addCriterion("CHECK_STATE <>", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateGreaterThan(Integer value) {
            addCriterion("CHECK_STATE >", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("CHECK_STATE >=", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateLessThan(Integer value) {
            addCriterion("CHECK_STATE <", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateLessThanOrEqualTo(Integer value) {
            addCriterion("CHECK_STATE <=", value, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateIn(List<Integer> values) {
            addCriterion("CHECK_STATE in", values, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateNotIn(List<Integer> values) {
            addCriterion("CHECK_STATE not in", values, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateBetween(Integer value1, Integer value2) {
            addCriterion("CHECK_STATE between", value1, value2, "checkState");
            return (Criteria) this;
        }

        public Criteria andCheckStateNotBetween(Integer value1, Integer value2) {
            addCriterion("CHECK_STATE not between", value1, value2, "checkState");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivIsNull() {
            addCriterion("ADMINISTRATIVE_DIV is null");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivIsNotNull() {
            addCriterion("ADMINISTRATIVE_DIV is not null");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivEqualTo(String value) {
            addCriterion("ADMINISTRATIVE_DIV =", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivNotEqualTo(String value) {
            addCriterion("ADMINISTRATIVE_DIV <>", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivGreaterThan(String value) {
            addCriterion("ADMINISTRATIVE_DIV >", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivGreaterThanOrEqualTo(String value) {
            addCriterion("ADMINISTRATIVE_DIV >=", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivLessThan(String value) {
            addCriterion("ADMINISTRATIVE_DIV <", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivLessThanOrEqualTo(String value) {
            addCriterion("ADMINISTRATIVE_DIV <=", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivLike(String value) {
            addCriterion("ADMINISTRATIVE_DIV like", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivNotLike(String value) {
            addCriterion("ADMINISTRATIVE_DIV not like", value, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivIn(List<String> values) {
            addCriterion("ADMINISTRATIVE_DIV in", values, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivNotIn(List<String> values) {
            addCriterion("ADMINISTRATIVE_DIV not in", values, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivBetween(String value1, String value2) {
            addCriterion("ADMINISTRATIVE_DIV between", value1, value2, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andAdministrativeDivNotBetween(String value1, String value2) {
            addCriterion("ADMINISTRATIVE_DIV not between", value1, value2, "administrativeDiv");
            return (Criteria) this;
        }

        public Criteria andCdUptimeIsNull() {
            addCriterion("CD_UPTIME is null");
            return (Criteria) this;
        }

        public Criteria andCdUptimeIsNotNull() {
            addCriterion("CD_UPTIME is not null");
            return (Criteria) this;
        }

        public Criteria andCdUptimeEqualTo(Date value) {
            addCriterion("CD_UPTIME =", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeNotEqualTo(Date value) {
            addCriterion("CD_UPTIME <>", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeGreaterThan(Date value) {
            addCriterion("CD_UPTIME >", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CD_UPTIME >=", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeLessThan(Date value) {
            addCriterion("CD_UPTIME <", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeLessThanOrEqualTo(Date value) {
            addCriterion("CD_UPTIME <=", value, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeIn(List<Date> values) {
            addCriterion("CD_UPTIME in", values, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeNotIn(List<Date> values) {
            addCriterion("CD_UPTIME not in", values, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeBetween(Date value1, Date value2) {
            addCriterion("CD_UPTIME between", value1, value2, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andCdUptimeNotBetween(Date value1, Date value2) {
            addCriterion("CD_UPTIME not between", value1, value2, "cdUptime");
            return (Criteria) this;
        }

        public Criteria andDelStateIsNull() {
            addCriterion("DEL_STATE is null");
            return (Criteria) this;
        }

        public Criteria andDelStateIsNotNull() {
            addCriterion("DEL_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andDelStateEqualTo(Integer value) {
            addCriterion("DEL_STATE =", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateNotEqualTo(Integer value) {
            addCriterion("DEL_STATE <>", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateGreaterThan(Integer value) {
            addCriterion("DEL_STATE >", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEL_STATE >=", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateLessThan(Integer value) {
            addCriterion("DEL_STATE <", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateLessThanOrEqualTo(Integer value) {
            addCriterion("DEL_STATE <=", value, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateIn(List<Integer> values) {
            addCriterion("DEL_STATE in", values, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateNotIn(List<Integer> values) {
            addCriterion("DEL_STATE not in", values, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateBetween(Integer value1, Integer value2) {
            addCriterion("DEL_STATE between", value1, value2, "delState");
            return (Criteria) this;
        }

        public Criteria andDelStateNotBetween(Integer value1, Integer value2) {
            addCriterion("DEL_STATE not between", value1, value2, "delState");
            return (Criteria) this;
        }

        public Criteria andSyncSignIsNull() {
            addCriterion("SYNC_SIGN is null");
            return (Criteria) this;
        }

        public Criteria andSyncSignIsNotNull() {
            addCriterion("SYNC_SIGN is not null");
            return (Criteria) this;
        }

        public Criteria andSyncSignEqualTo(Integer value) {
            addCriterion("SYNC_SIGN =", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignNotEqualTo(Integer value) {
            addCriterion("SYNC_SIGN <>", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignGreaterThan(Integer value) {
            addCriterion("SYNC_SIGN >", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignGreaterThanOrEqualTo(Integer value) {
            addCriterion("SYNC_SIGN >=", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignLessThan(Integer value) {
            addCriterion("SYNC_SIGN <", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignLessThanOrEqualTo(Integer value) {
            addCriterion("SYNC_SIGN <=", value, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignIn(List<Integer> values) {
            addCriterion("SYNC_SIGN in", values, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignNotIn(List<Integer> values) {
            addCriterion("SYNC_SIGN not in", values, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignBetween(Integer value1, Integer value2) {
            addCriterion("SYNC_SIGN between", value1, value2, "syncSign");
            return (Criteria) this;
        }

        public Criteria andSyncSignNotBetween(Integer value1, Integer value2) {
            addCriterion("SYNC_SIGN not between", value1, value2, "syncSign");
            return (Criteria) this;
        }

        public Criteria andCdTimeIsNull() {
            addCriterion("CD_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCdTimeIsNotNull() {
            addCriterion("CD_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCdTimeEqualTo(Date value) {
            addCriterion("CD_TIME =", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeNotEqualTo(Date value) {
            addCriterion("CD_TIME <>", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeGreaterThan(Date value) {
            addCriterion("CD_TIME >", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CD_TIME >=", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeLessThan(Date value) {
            addCriterion("CD_TIME <", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeLessThanOrEqualTo(Date value) {
            addCriterion("CD_TIME <=", value, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeIn(List<Date> values) {
            addCriterion("CD_TIME in", values, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeNotIn(List<Date> values) {
            addCriterion("CD_TIME not in", values, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeBetween(Date value1, Date value2) {
            addCriterion("CD_TIME between", value1, value2, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdTimeNotBetween(Date value1, Date value2) {
            addCriterion("CD_TIME not between", value1, value2, "cdTime");
            return (Criteria) this;
        }

        public Criteria andCdBatchIsNull() {
            addCriterion("CD_BATCH is null");
            return (Criteria) this;
        }

        public Criteria andCdBatchIsNotNull() {
            addCriterion("CD_BATCH is not null");
            return (Criteria) this;
        }

        public Criteria andCdBatchEqualTo(String value) {
            addCriterion("CD_BATCH =", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotEqualTo(String value) {
            addCriterion("CD_BATCH <>", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchGreaterThan(String value) {
            addCriterion("CD_BATCH >", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchGreaterThanOrEqualTo(String value) {
            addCriterion("CD_BATCH >=", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchLessThan(String value) {
            addCriterion("CD_BATCH <", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchLessThanOrEqualTo(String value) {
            addCriterion("CD_BATCH <=", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchLike(String value) {
            addCriterion("CD_BATCH like", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotLike(String value) {
            addCriterion("CD_BATCH not like", value, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchIn(List<String> values) {
            addCriterion("CD_BATCH in", values, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotIn(List<String> values) {
            addCriterion("CD_BATCH not in", values, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchBetween(String value1, String value2) {
            addCriterion("CD_BATCH between", value1, value2, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andCdBatchNotBetween(String value1, String value2) {
            addCriterion("CD_BATCH not between", value1, value2, "cdBatch");
            return (Criteria) this;
        }

        public Criteria andDatasourceIsNull() {
            addCriterion("DATASOURCE is null");
            return (Criteria) this;
        }

        public Criteria andDatasourceIsNotNull() {
            addCriterion("DATASOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andDatasourceEqualTo(String value) {
            addCriterion("DATASOURCE =", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotEqualTo(String value) {
            addCriterion("DATASOURCE <>", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceGreaterThan(String value) {
            addCriterion("DATASOURCE >", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceGreaterThanOrEqualTo(String value) {
            addCriterion("DATASOURCE >=", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceLessThan(String value) {
            addCriterion("DATASOURCE <", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceLessThanOrEqualTo(String value) {
            addCriterion("DATASOURCE <=", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceLike(String value) {
            addCriterion("DATASOURCE like", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotLike(String value) {
            addCriterion("DATASOURCE not like", value, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceIn(List<String> values) {
            addCriterion("DATASOURCE in", values, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotIn(List<String> values) {
            addCriterion("DATASOURCE not in", values, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceBetween(String value1, String value2) {
            addCriterion("DATASOURCE between", value1, value2, "datasource");
            return (Criteria) this;
        }

        public Criteria andDatasourceNotBetween(String value1, String value2) {
            addCriterion("DATASOURCE not between", value1, value2, "datasource");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}